{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# -*- codeing = utf-8 -*-\n",
    "from bs4 import BeautifulSoup           # 网页解析\n",
    "import requests     # URL操作，获取网页数据\n",
    "import pandas as pd\n",
    "from sqlalchemy import create_engine\n",
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 请求伪装成浏览器\n",
    "hearders = {'User-Agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "光之子 Child of Light 获取信息标签列表错误 'NoneType' object has no attribute 'find_all'\n"
     ]
    }
   ],
   "source": [
    "names = ['光之子','狂神','空速星痕','琴帝','冰火魔厨','惟我独仙','酒神','天珠变','为了你我愿意热爱整个世界','神印王座','斗罗大陆','天火大道']\n",
    "res = []\n",
    "for name in names:\n",
    "    # url = f'https://www.douban.com/search?cat=1002&q={name}' # 仅影视\n",
    "    url = f'https://www.douban.com/search?q={name}'\n",
    "    # 获取查询结果，解析为soup\n",
    "    request = requests.get(url,headers=hearders)\n",
    "    soup = BeautifulSoup(request.text, \"html.parser\")\n",
    "    # 获取查询结果列表\n",
    "    information_list = soup.find('div', class_='result-list').find_all('div',class_='result')\n",
    "    li = []\n",
    "    for information in information_list:\n",
    "        # 获取详细信息链接\n",
    "        if name not in information.find('h3').find('a').text:\n",
    "            continue\n",
    "        information_url = information.find('h3').find('a')['href']\n",
    "        # 获取详细信息页面，解析为soup\n",
    "        request_inf = requests.get(information_url,headers=hearders)\n",
    "        soup_inf = BeautifulSoup(request_inf.text, \"html.parser\")\n",
    "        # 定位信息标签\n",
    "        info = soup_inf.find('div',id='info')\n",
    "        # 获取信息标签列表\n",
    "        try:\n",
    "            pl = info.find_all('span',class_='pl')\n",
    "        except Exception as e:\n",
    "            print(information.find('h3').find('a').text,'获取信息标签列表错误',e)\n",
    "            continue\n",
    "        # 解析信息，生成字典\n",
    "        dic = {}\n",
    "        dic['系列'] = name\n",
    "        dic['名称'] = soup_inf.find('span',property='v:itemreviewed').text\n",
    "        for i in pl:\n",
    "            key =re.sub(r'[ :]','',i.text)\n",
    "            if i.parent.name == 'span':\n",
    "                try:\n",
    "                    dic[key] = i.parent.find('span',class_='attrs').text\n",
    "                except Exception as e:\n",
    "                    dic[key] = i.parent.find('a').text\n",
    "            elif i.next_sibling.next_sibling.name == \"a\":\n",
    "                dic[key] = i.next_sibling.next_sibling.text.replace('\\n','')\n",
    "            elif i.text == '类型:':\n",
    "                genre = ''\n",
    "                for j in info.find_all('span',property='v:genre'):\n",
    "                    genre = genre+j.text+'/'\n",
    "                dic[key] = genre[:-1]\n",
    "            elif i.text == '首播:' or i.text == '上映日期:':\n",
    "                dic[key] = info.find('span',property='v:initialReleaseDate').text[:10]\n",
    "            elif i.text == '片长:':\n",
    "                dic[key] = info.find('span',property='v:runtime').text\n",
    "            else:\n",
    "                dic[key] = i.next_sibling.replace(' ','')\n",
    "        li.append(dic)\n",
    "    res.extend(li)\n",
    "\n",
    "df = pd.DataFrame(res)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>系列</th>\n",
       "      <th>名称</th>\n",
       "      <th>作者</th>\n",
       "      <th>出版社</th>\n",
       "      <th>出版年</th>\n",
       "      <th>页数</th>\n",
       "      <th>定价</th>\n",
       "      <th>装帧</th>\n",
       "      <th>ISBN</th>\n",
       "      <th>导演</th>\n",
       "      <th>...</th>\n",
       "      <th>片长</th>\n",
       "      <th>又名</th>\n",
       "      <th>IMDb</th>\n",
       "      <th>副标题</th>\n",
       "      <th>丛书</th>\n",
       "      <th>主演</th>\n",
       "      <th>首播</th>\n",
       "      <th>集数</th>\n",
       "      <th>单集片长</th>\n",
       "      <th>季数</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>光之子</td>\n",
       "      <td>光之子</td>\n",
       "      <td>唐家三少</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2018-7-1</td>\n",
       "      <td>1096</td>\n",
       "      <td>CNY118.00</td>\n",
       "      <td>平装</td>\n",
       "      <td>9787540483067</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>光之子</td>\n",
       "      <td>光之子</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>卡先加</td>\n",
       "      <td>...</td>\n",
       "      <td>100分钟</td>\n",
       "      <td>DaughteroftheLight</td>\n",
       "      <td>tt12630666</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>狂神</td>\n",
       "      <td>狂神</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2005-12</td>\n",
       "      <td>273</td>\n",
       "      <td>22.00元</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9787806479223</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>龙神帝国</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>空速星痕</td>\n",
       "      <td>空速星痕</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2006-09-22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.00元</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9787531720249</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>琴帝</td>\n",
       "      <td>琴帝</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2008-05</td>\n",
       "      <td>267</td>\n",
       "      <td>26.00元</td>\n",
       "      <td>平装</td>\n",
       "      <td>9787806806081</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>六道之决</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>琴帝</td>\n",
       "      <td>琴帝1·千手琴音</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2012-4</td>\n",
       "      <td>299</td>\n",
       "      <td>28.00元</td>\n",
       "      <td>平装</td>\n",
       "      <td>9787551301602</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>冰火魔厨</td>\n",
       "      <td>冰火魔厨</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>陈逸达</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TheMagicChefofIceandFire</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>张杰 / 山新 / 徐佳琦 / 聂曦映 / 老鬼 / 林强 / 歪歪 / 李诗萌 / 赵爽 ...</td>\n",
       "      <td>2021-12-11</td>\n",
       "      <td>52</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>冰火魔厨</td>\n",
       "      <td>冰火魔厨2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>汶静 / 蔡宏林</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>冰火魔厨第二季/TheMagicChefofIceandFire</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>张杰 / 山新 / 聂曦映 / 蔡海婷 / 陈麟灵 / 王靖扬 / 刘一鸣 / 张加麒 / ...</td>\n",
       "      <td>2022-12-03</td>\n",
       "      <td>52</td>\n",
       "      <td>20分钟</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>冰火魔厨</td>\n",
       "      <td>冰火魔厨</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2007-07-16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9787811200980</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>冰火魔厨</td>\n",
       "      <td>冰火魔厨</td>\n",
       "      <td>唐家三少 著</td>\n",
       "      <td>\\n</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.00元</td>\n",
       "      <td>平装</td>\n",
       "      <td>9787811201048</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>冰火魔厨</td>\n",
       "      <td>冰火魔厨</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2007-03-30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9787531721031</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>冰火魔厨</td>\n",
       "      <td>冰火魔厨7</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2013-1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.00元</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9787807135562</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>惟我独仙</td>\n",
       "      <td>惟我独仙（典藏版1）</td>\n",
       "      <td>NaN</td>\n",
       "      <td>\\n</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.20元</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9787547426609</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>酒神</td>\n",
       "      <td>酒神小姐 죽여주는 여자</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李在容</td>\n",
       "      <td>...</td>\n",
       "      <td>111分钟</td>\n",
       "      <td>神女观音(港)/巴克斯奶奶的性福配方(台)/宝佳适女郎(豆友译名)/TheBacchusLady</td>\n",
       "      <td>tt5628012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>尹汝贞 / 全茂松 / 尹启相</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>酒神</td>\n",
       "      <td>别叫我酒神</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>王岩川</td>\n",
       "      <td>...</td>\n",
       "      <td>82分钟</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>宋晓峰 / 秦立洋 / 崔菁格</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>酒神</td>\n",
       "      <td>别叫我酒神2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>王岩川</td>\n",
       "      <td>...</td>\n",
       "      <td>94分钟</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>宋晓峰 / 崔菁格 / 黄继栋 / 张蓝艺 / 罗辑</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>酒神</td>\n",
       "      <td>酒神美学</td>\n",
       "      <td>尼采</td>\n",
       "      <td>\\n</td>\n",
       "      <td>NaN</td>\n",
       "      <td>355</td>\n",
       "      <td>58.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9787100189941</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>尼采艺术哲学经典文选</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>酒神</td>\n",
       "      <td>酒神（全14卷）</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2010-7</td>\n",
       "      <td>267</td>\n",
       "      <td>26.00元</td>\n",
       "      <td>平装</td>\n",
       "      <td>9787806808375</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>天珠变</td>\n",
       "      <td>天珠变</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2013-3</td>\n",
       "      <td>283</td>\n",
       "      <td>28.00元</td>\n",
       "      <td>平装</td>\n",
       "      <td>9787551303026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>为了你我愿意热爱整个世界</td>\n",
       "      <td>为了你我愿意热爱整个世界</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>余翠华 / 郭虎</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>为了你，我愿意热爱整个世界/为了你</td>\n",
       "      <td>tt6771842</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>罗晋 / 张艺上 / 庞瀚辰 / 王宫良 / 杨金承 / 孔琳 / 李依伊 / 罗钢 / 孙...</td>\n",
       "      <td>2018-06-18</td>\n",
       "      <td>48</td>\n",
       "      <td>40分钟</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>神印王座</td>\n",
       "      <td>神印王座</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>曾元俊 / 李健宁</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ThroneofSeal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>常蓉珊 / 瞳音 / 叶知秋 / 阎么么 / 藤新 / 刘明月</td>\n",
       "      <td>2022-04-28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20分钟</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>神印王座</td>\n",
       "      <td>神印王座之激战雄关</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>曾元俊 / 李健宁</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ThroneofSeal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>李轻扬 / 沈念如 / 常蓉珊 / 图特哈蒙 / 闫夜桥 / 杨天翔 / 刘明月 / 林帽帽...</td>\n",
       "      <td>2023-06-15</td>\n",
       "      <td>5</td>\n",
       "      <td>22分钟</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>神印王座</td>\n",
       "      <td>神印王座1</td>\n",
       "      <td>唐家三少</td>\n",
       "      <td>九星文化</td>\n",
       "      <td>2011-11-28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NTD170</td>\n",
       "      <td>平装</td>\n",
       "      <td>9789866022685</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>神印王座</td>\n",
       "      <td>神印王座</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>动态漫画版神印王座第一季</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2021-06-18</td>\n",
       "      <td>28</td>\n",
       "      <td>12分钟</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>神印王座</td>\n",
       "      <td>光明之子-神印王座-I</td>\n",
       "      <td>唐家三少</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2011-11</td>\n",
       "      <td>318</td>\n",
       "      <td>24.80元</td>\n",
       "      <td>平装</td>\n",
       "      <td>9787547405406</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>神印王座</td>\n",
       "      <td>神印王座9·魔神之陨</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2012-12</td>\n",
       "      <td>318</td>\n",
       "      <td>24.80元</td>\n",
       "      <td>平装</td>\n",
       "      <td>9787547408261</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>神印王座</td>\n",
       "      <td>神印王座(典藏版1)</td>\n",
       "      <td>唐家三少</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2017-09-01</td>\n",
       "      <td>284</td>\n",
       "      <td>32.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9787556232512</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>神印王座</td>\n",
       "      <td>神印王座2·圣盟试炼</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2011-12</td>\n",
       "      <td>317</td>\n",
       "      <td>24.80元</td>\n",
       "      <td>平装</td>\n",
       "      <td>9787547405710</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>斗罗大陆</td>\n",
       "      <td>斗罗大陆1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈乐平</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>斗罗大陆动画版/斗罗大陆第一季/SoulLand</td>\n",
       "      <td>tt8948436</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈磊 / 程玉珠 / 黄翔宇 / 王肖兵 / 倪康 / 赵乾景 / 吴磊 / 张琦 / 秦紫翼</td>\n",
       "      <td>2018-01-20</td>\n",
       "      <td>26</td>\n",
       "      <td>20分钟</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>斗罗大陆</td>\n",
       "      <td>斗罗大陆</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>杨振宇</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>斗罗大陆电视剧/DouLuoContinent/SoulLand</td>\n",
       "      <td>tt12526224</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>肖战 / 吴宣仪 / 辰亦儒 / 邱心志 / 钟镇涛 / 朱珠 / 高泰宇 / 黄灿灿 / ...</td>\n",
       "      <td>2021-02-05</td>\n",
       "      <td>40</td>\n",
       "      <td>40分钟</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>斗罗大陆</td>\n",
       "      <td>斗罗大陆2：绝世唐门</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈乐平</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>斗罗大陆Ⅱ绝世唐门/绝世唐门动画版/斗罗大陆2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>梁达伟</td>\n",
       "      <td>2023-06-24</td>\n",
       "      <td>52</td>\n",
       "      <td>20分钟</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>斗罗大陆</td>\n",
       "      <td>斗罗大陆</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>斗罗大陆剧场版</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>斗罗大陆</td>\n",
       "      <td>斗罗大陆1 第二十部分</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈乐平</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>唐门绝顶/斗罗大陆第一季第二十部分/SoulLand/斗罗大陆动画版</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈磊</td>\n",
       "      <td>2022-10-22</td>\n",
       "      <td>3</td>\n",
       "      <td>20分钟-22分钟</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>斗罗大陆</td>\n",
       "      <td>斗罗大陆（全14卷）</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2009-7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>364.00元</td>\n",
       "      <td>平装</td>\n",
       "      <td>9787806806890</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>斗罗大陆</td>\n",
       "      <td>斗罗大陆1 第六部分</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈乐平</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>斗罗大陆第一季Part.6/斗罗大陆星斗献祭</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈磊 / 程玉珠 / 黄翔宇 / 王肖兵 / 倪康 / 赵乾景 / 吴磊 / 张琦 / 秦紫翼</td>\n",
       "      <td>2020-08-22</td>\n",
       "      <td>13</td>\n",
       "      <td>15</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>斗罗大陆</td>\n",
       "      <td>斗罗大陆2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>斗罗大陆之绝世唐门/斗罗大陆2电视剧版/斗罗大陆第二季/剧版斗罗大陆2</td>\n",
       "      <td>tt27305026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>周翊然 / 张予曦 / 陈牧驰 / 孔雪儿 / 许佳琪 / 储子竣 / 周静波 / 丁嘉毅</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38</td>\n",
       "      <td>45分钟</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>斗罗大陆</td>\n",
       "      <td>斗罗大陆1 第七部分</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈乐平</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>斗罗大陆第一季Part.7/斗罗大陆瀚海乾坤</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈磊 / 程玉珠 / 黄翔宇 / 王肖兵 / 倪康 / 赵乾景 / 张琦 / 秦紫翼</td>\n",
       "      <td>2020-11-21</td>\n",
       "      <td>13</td>\n",
       "      <td>20分钟</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>斗罗大陆</td>\n",
       "      <td>斗罗大陆1 第十八部分</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈乐平</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>斗罗大陆之怒世鏖战</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沈磊 / 程玉珠 / 黄翔宇</td>\n",
       "      <td>2022-09-03</td>\n",
       "      <td>3</td>\n",
       "      <td>20</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>天火大道</td>\n",
       "      <td>天火大道</td>\n",
       "      <td>\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>2015-11-1</td>\n",
       "      <td>302</td>\n",
       "      <td>CNY28.00</td>\n",
       "      <td>平装</td>\n",
       "      <td>9787556216109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>39 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              系列            名称      作者   出版社         出版年    页数         定价  \\\n",
       "0            光之子           光之子    唐家三少    \\n    2018-7-1  1096  CNY118.00   \n",
       "1            光之子           光之子     NaN   NaN         NaN   NaN        NaN   \n",
       "2             狂神            狂神      \\n    \\n     2005-12   273     22.00元   \n",
       "3           空速星痕          空速星痕      \\n    \\n  2006-09-22   NaN     22.00元   \n",
       "4             琴帝            琴帝      \\n    \\n     2008-05   267     26.00元   \n",
       "5             琴帝      琴帝1·千手琴音      \\n    \\n      2012-4   299     28.00元   \n",
       "6           冰火魔厨          冰火魔厨     NaN   NaN         NaN   NaN        NaN   \n",
       "7           冰火魔厨         冰火魔厨2     NaN   NaN         NaN   NaN        NaN   \n",
       "8           冰火魔厨          冰火魔厨      \\n    \\n  2007-07-16   NaN       22.0   \n",
       "9           冰火魔厨          冰火魔厨  唐家三少 著    \\n         NaN   NaN     22.00元   \n",
       "10          冰火魔厨          冰火魔厨      \\n    \\n  2007-03-30   NaN       22.0   \n",
       "11          冰火魔厨         冰火魔厨7      \\n    \\n      2013-1   NaN     15.00元   \n",
       "12          惟我独仙    惟我独仙（典藏版1）     NaN    \\n         NaN   NaN     21.20元   \n",
       "13            酒神  酒神小姐 죽여주는 여자     NaN   NaN         NaN   NaN        NaN   \n",
       "14            酒神         别叫我酒神     NaN   NaN         NaN   NaN        NaN   \n",
       "15            酒神        别叫我酒神2     NaN   NaN         NaN   NaN        NaN   \n",
       "16            酒神          酒神美学      尼采    \\n         NaN   355      58.00   \n",
       "17            酒神      酒神（全14卷）      \\n    \\n      2010-7   267     26.00元   \n",
       "18           天珠变           天珠变      \\n    \\n      2013-3   283     28.00元   \n",
       "19  为了你我愿意热爱整个世界  为了你我愿意热爱整个世界     NaN   NaN         NaN   NaN        NaN   \n",
       "20          神印王座          神印王座     NaN   NaN         NaN   NaN        NaN   \n",
       "21          神印王座     神印王座之激战雄关     NaN   NaN         NaN   NaN        NaN   \n",
       "22          神印王座         神印王座1    唐家三少  九星文化  2011-11-28   NaN     NTD170   \n",
       "23          神印王座          神印王座     NaN   NaN         NaN   NaN        NaN   \n",
       "24          神印王座   光明之子-神印王座-I    唐家三少    \\n     2011-11   318     24.80元   \n",
       "25          神印王座    神印王座9·魔神之陨      \\n    \\n     2012-12   318     24.80元   \n",
       "26          神印王座    神印王座(典藏版1)    唐家三少    \\n  2017-09-01   284       32.8   \n",
       "27          神印王座    神印王座2·圣盟试炼      \\n    \\n     2011-12   317     24.80元   \n",
       "28          斗罗大陆         斗罗大陆1     NaN   NaN         NaN   NaN        NaN   \n",
       "29          斗罗大陆          斗罗大陆     NaN   NaN         NaN   NaN        NaN   \n",
       "30          斗罗大陆    斗罗大陆2：绝世唐门     NaN   NaN         NaN   NaN        NaN   \n",
       "31          斗罗大陆          斗罗大陆     NaN   NaN         NaN   NaN        NaN   \n",
       "32          斗罗大陆   斗罗大陆1 第二十部分     NaN   NaN         NaN   NaN        NaN   \n",
       "33          斗罗大陆    斗罗大陆（全14卷）      \\n    \\n      2009-7   NaN    364.00元   \n",
       "34          斗罗大陆    斗罗大陆1 第六部分     NaN   NaN         NaN   NaN        NaN   \n",
       "35          斗罗大陆         斗罗大陆2     NaN   NaN         NaN   NaN        NaN   \n",
       "36          斗罗大陆    斗罗大陆1 第七部分     NaN   NaN         NaN   NaN        NaN   \n",
       "37          斗罗大陆   斗罗大陆1 第十八部分     NaN   NaN         NaN   NaN        NaN   \n",
       "38          天火大道          天火大道      \\n    \\n   2015-11-1   302   CNY28.00   \n",
       "\n",
       "     装帧           ISBN         导演  ...     片长  \\\n",
       "0    平装  9787540483067        NaN  ...    NaN   \n",
       "1   NaN            NaN        卡先加  ...  100分钟   \n",
       "2   NaN  9787806479223        NaN  ...    NaN   \n",
       "3   NaN  9787531720249        NaN  ...    NaN   \n",
       "4    平装  9787806806081        NaN  ...    NaN   \n",
       "5    平装  9787551301602        NaN  ...    NaN   \n",
       "6   NaN            NaN        陈逸达  ...    NaN   \n",
       "7   NaN            NaN   汶静 / 蔡宏林  ...    NaN   \n",
       "8   NaN  9787811200980        NaN  ...    NaN   \n",
       "9    平装  9787811201048        NaN  ...    NaN   \n",
       "10  NaN  9787531721031        NaN  ...    NaN   \n",
       "11  NaN  9787807135562        NaN  ...    NaN   \n",
       "12  NaN  9787547426609        NaN  ...    NaN   \n",
       "13  NaN            NaN        李在容  ...  111分钟   \n",
       "14  NaN            NaN        王岩川  ...   82分钟   \n",
       "15  NaN            NaN        王岩川  ...   94分钟   \n",
       "16  NaN  9787100189941        NaN  ...    NaN   \n",
       "17   平装  9787806808375        NaN  ...    NaN   \n",
       "18   平装  9787551303026        NaN  ...    NaN   \n",
       "19  NaN            NaN   余翠华 / 郭虎  ...    NaN   \n",
       "20  NaN            NaN  曾元俊 / 李健宁  ...    NaN   \n",
       "21  NaN            NaN  曾元俊 / 李健宁  ...    NaN   \n",
       "22   平装  9789866022685        NaN  ...    NaN   \n",
       "23  NaN            NaN        NaN  ...    NaN   \n",
       "24   平装  9787547405406        NaN  ...    NaN   \n",
       "25   平装  9787547408261        NaN  ...    NaN   \n",
       "26  NaN  9787556232512        NaN  ...    NaN   \n",
       "27   平装  9787547405710        NaN  ...    NaN   \n",
       "28  NaN            NaN        沈乐平  ...    NaN   \n",
       "29  NaN            NaN        杨振宇  ...    NaN   \n",
       "30  NaN            NaN        沈乐平  ...    NaN   \n",
       "31  NaN            NaN        NaN  ...    NaN   \n",
       "32  NaN            NaN        沈乐平  ...    NaN   \n",
       "33   平装  9787806806890        NaN  ...    NaN   \n",
       "34  NaN            NaN        沈乐平  ...    NaN   \n",
       "35  NaN            NaN        NaN  ...    NaN   \n",
       "36  NaN            NaN        沈乐平  ...    NaN   \n",
       "37  NaN            NaN        沈乐平  ...    NaN   \n",
       "38   平装  9787556216109        NaN  ...    NaN   \n",
       "\n",
       "                                                  又名        IMDb         副标题  \\\n",
       "0                                                NaN         NaN         NaN   \n",
       "1                                 DaughteroftheLight  tt12630666         NaN   \n",
       "2                                                NaN         NaN        龙神帝国   \n",
       "3                                                NaN         NaN         NaN   \n",
       "4                                                NaN         NaN        六道之决   \n",
       "5                                                NaN         NaN         NaN   \n",
       "6                           TheMagicChefofIceandFire         NaN         NaN   \n",
       "7                   冰火魔厨第二季/TheMagicChefofIceandFire         NaN         NaN   \n",
       "8                                                NaN         NaN         NaN   \n",
       "9                                                NaN         NaN         NaN   \n",
       "10                                               NaN         NaN         NaN   \n",
       "11                                               NaN         NaN         NaN   \n",
       "12                                               NaN         NaN         NaN   \n",
       "13  神女观音(港)/巴克斯奶奶的性福配方(台)/宝佳适女郎(豆友译名)/TheBacchusLady   tt5628012         NaN   \n",
       "14                                               NaN         NaN         NaN   \n",
       "15                                               NaN         NaN         NaN   \n",
       "16                                               NaN         NaN  尼采艺术哲学经典文选   \n",
       "17                                               NaN         NaN         NaN   \n",
       "18                                               NaN         NaN         NaN   \n",
       "19                                 为了你，我愿意热爱整个世界/为了你   tt6771842         NaN   \n",
       "20                                      ThroneofSeal         NaN         NaN   \n",
       "21                                      ThroneofSeal         NaN         NaN   \n",
       "22                                               NaN         NaN         NaN   \n",
       "23                                      动态漫画版神印王座第一季         NaN         NaN   \n",
       "24                                               NaN         NaN         NaN   \n",
       "25                                               NaN         NaN         NaN   \n",
       "26                                               NaN         NaN         NaN   \n",
       "27                                               NaN         NaN         NaN   \n",
       "28                          斗罗大陆动画版/斗罗大陆第一季/SoulLand   tt8948436         NaN   \n",
       "29                  斗罗大陆电视剧/DouLuoContinent/SoulLand  tt12526224         NaN   \n",
       "30                           斗罗大陆Ⅱ绝世唐门/绝世唐门动画版/斗罗大陆2         NaN         NaN   \n",
       "31                                           斗罗大陆剧场版         NaN         NaN   \n",
       "32                唐门绝顶/斗罗大陆第一季第二十部分/SoulLand/斗罗大陆动画版         NaN         NaN   \n",
       "33                                               NaN         NaN         NaN   \n",
       "34                            斗罗大陆第一季Part.6/斗罗大陆星斗献祭         NaN         NaN   \n",
       "35               斗罗大陆之绝世唐门/斗罗大陆2电视剧版/斗罗大陆第二季/剧版斗罗大陆2  tt27305026         NaN   \n",
       "36                            斗罗大陆第一季Part.7/斗罗大陆瀚海乾坤         NaN         NaN   \n",
       "37                                         斗罗大陆之怒世鏖战         NaN         NaN   \n",
       "38                                               NaN         NaN         NaN   \n",
       "\n",
       "     丛书                                                 主演          首播   集数  \\\n",
       "0   NaN                                                NaN         NaN  NaN   \n",
       "1   NaN                                                NaN         NaN  NaN   \n",
       "2                                                      NaN         NaN  NaN   \n",
       "3   NaN                                                NaN         NaN  NaN   \n",
       "4   NaN                                                NaN         NaN  NaN   \n",
       "5                                                      NaN         NaN  NaN   \n",
       "6   NaN  张杰 / 山新 / 徐佳琦 / 聂曦映 / 老鬼 / 林强 / 歪歪 / 李诗萌 / 赵爽 ...  2021-12-11   52   \n",
       "7   NaN  张杰 / 山新 / 聂曦映 / 蔡海婷 / 陈麟灵 / 王靖扬 / 刘一鸣 / 张加麒 / ...  2022-12-03   52   \n",
       "8   NaN                                                NaN         NaN  NaN   \n",
       "9   NaN                                                NaN         NaN  NaN   \n",
       "10  NaN                                                NaN         NaN  NaN   \n",
       "11  NaN                                                NaN         NaN  NaN   \n",
       "12  NaN                                                NaN         NaN  NaN   \n",
       "13  NaN                                    尹汝贞 / 全茂松 / 尹启相         NaN  NaN   \n",
       "14  NaN                                    宋晓峰 / 秦立洋 / 崔菁格         NaN  NaN   \n",
       "15  NaN                         宋晓峰 / 崔菁格 / 黄继栋 / 张蓝艺 / 罗辑         NaN  NaN   \n",
       "16  NaN                                                NaN         NaN  NaN   \n",
       "17  NaN                                                NaN         NaN  NaN   \n",
       "18  NaN                                                NaN         NaN  NaN   \n",
       "19  NaN  罗晋 / 张艺上 / 庞瀚辰 / 王宫良 / 杨金承 / 孔琳 / 李依伊 / 罗钢 / 孙...  2018-06-18   48   \n",
       "20  NaN                    常蓉珊 / 瞳音 / 叶知秋 / 阎么么 / 藤新 / 刘明月  2022-04-28  NaN   \n",
       "21  NaN  李轻扬 / 沈念如 / 常蓉珊 / 图特哈蒙 / 闫夜桥 / 杨天翔 / 刘明月 / 林帽帽...  2023-06-15    5   \n",
       "22                                                     NaN         NaN  NaN   \n",
       "23  NaN                                                NaN  2021-06-18   28   \n",
       "24                                                     NaN         NaN  NaN   \n",
       "25                                                     NaN         NaN  NaN   \n",
       "26  NaN                                                NaN         NaN  NaN   \n",
       "27                                                     NaN         NaN  NaN   \n",
       "28  NaN    沈磊 / 程玉珠 / 黄翔宇 / 王肖兵 / 倪康 / 赵乾景 / 吴磊 / 张琦 / 秦紫翼  2018-01-20   26   \n",
       "29  NaN  肖战 / 吴宣仪 / 辰亦儒 / 邱心志 / 钟镇涛 / 朱珠 / 高泰宇 / 黄灿灿 / ...  2021-02-05   40   \n",
       "30  NaN                                                梁达伟  2023-06-24   52   \n",
       "31  NaN                                                NaN         NaN  NaN   \n",
       "32  NaN                                                 沈磊  2022-10-22    3   \n",
       "33  NaN                                                NaN         NaN  NaN   \n",
       "34  NaN    沈磊 / 程玉珠 / 黄翔宇 / 王肖兵 / 倪康 / 赵乾景 / 吴磊 / 张琦 / 秦紫翼  2020-08-22   13   \n",
       "35  NaN      周翊然 / 张予曦 / 陈牧驰 / 孔雪儿 / 许佳琪 / 储子竣 / 周静波 / 丁嘉毅         NaN   38   \n",
       "36  NaN         沈磊 / 程玉珠 / 黄翔宇 / 王肖兵 / 倪康 / 赵乾景 / 张琦 / 秦紫翼  2020-11-21   13   \n",
       "37  NaN                                     沈磊 / 程玉珠 / 黄翔宇  2022-09-03    3   \n",
       "38                                                     NaN         NaN  NaN   \n",
       "\n",
       "         单集片长   季数  \n",
       "0         NaN  NaN  \n",
       "1         NaN  NaN  \n",
       "2         NaN  NaN  \n",
       "3         NaN  NaN  \n",
       "4         NaN  NaN  \n",
       "5         NaN  NaN  \n",
       "6          20  NaN  \n",
       "7        20分钟    2  \n",
       "8         NaN  NaN  \n",
       "9         NaN  NaN  \n",
       "10        NaN  NaN  \n",
       "11        NaN  NaN  \n",
       "12        NaN  NaN  \n",
       "13        NaN  NaN  \n",
       "14        NaN  NaN  \n",
       "15        NaN  NaN  \n",
       "16        NaN  NaN  \n",
       "17        NaN  NaN  \n",
       "18        NaN  NaN  \n",
       "19       40分钟  NaN  \n",
       "20       20分钟  NaN  \n",
       "21       22分钟  NaN  \n",
       "22        NaN  NaN  \n",
       "23       12分钟  NaN  \n",
       "24        NaN  NaN  \n",
       "25        NaN  NaN  \n",
       "26        NaN  NaN  \n",
       "27        NaN  NaN  \n",
       "28       20分钟  NaN  \n",
       "29       40分钟  NaN  \n",
       "30       20分钟    2  \n",
       "31        NaN  NaN  \n",
       "32  20分钟-22分钟  NaN  \n",
       "33        NaN  NaN  \n",
       "34         15    6  \n",
       "35       45分钟  NaN  \n",
       "36       20分钟    7  \n",
       "37         20   18  \n",
       "38        NaN  NaN  \n",
       "\n",
       "[39 rows x 25 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "d:\\Digital\\Anaconda3\\lib\\site-packages\\pandas\\io\\sql.py:1666: UserWarning: The provided table name 'NoInfo' is not found exactly as such in the database after writing the table, possibly due to case sensitivity issues. Consider using lower case table names.\n",
      "  warnings.warn(msg, UserWarning)\n"
     ]
    }
   ],
   "source": [
    "# 连接本地数据库\n",
    "engine = create_engine(\"mysql+pymysql://root:cy123789@127.0.0.1:3306/myhappiness?charset=utf8\")\n",
    "with engine.connect() as conn:\n",
    "    df.to_sql(\"NoInfo\", conn, if_exists=\"append\", index=False)\n",
    "\n",
    "engine.dispose()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'df' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m~\\AppData\\Local\\Temp\\ipykernel_1460\\3289350417.py\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mdf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m: name 'df' is not defined"
     ]
    }
   ],
   "source": [
    "df.columns"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
